/**
  创建 student 实体类
 */
 drop table student;
create table student(
    sid int primary key ,
    sname varchar(100),
    sage int,
    score float,
    sbirthday timestamp
);

-- 删除序列
drop sequence student_seq;
-- 创建序列
create sequence student_seq start with 1000;

-- 插入数据
insert into student values(student_seq.nextval,'韩梅梅',18,98,systimestamp);
insert into student values(student_seq.nextval,'韩庚',28,58,systimestamp);
insert into student values(student_seq.nextval,'韩雪',38,68,systimestamp);
insert into student values(student_seq.nextval,'韩寒',48,78,systimestamp);
insert into student values(student_seq.nextval,'韩红',58,28,to_date('1988-11-12 12:13:14','yyyy-mm-dd hh24:mi:ss'));
select * from student;



